versionupdatehistory
Table: versionupdatehistory
The versionupdatehistory table keeps track of application version updates for each user.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| versionUpdateHistory | int(11) | NO | Primary key identifying the version update record |
| createdDate | datetime | YES | Timestamp when the record was created |
| dateUpdated | datetime | YES | Timestamp of the version update |
| mappedId | int(11) | YES | User reference ID |
| versionNumber | varchar(255) | YES | Version number of the application |
Indexes
user_userId_mappedId_FK— Index onmappedId
Foreign Key Relations
mappedId → user.mappedId
Usage Notes
- Tracks which version of the application was updated for each user.
- Useful for debugging, analytics, and audit purposes.